Using the Measures Tree

The measures tree displays the data model's measures (quantitative data); from here, you can add measures to the query. The measure panel also exposes a number of other functions, and you can add a metadata overlay to measures by editing their properties.

Add Measures to the Query

Measures are added to the query primarily via the value drop zones, however it can be used in other ones like color, size, labels, tooltips and trellising. Each drop zone drives a corresponding component in the visualization. When multiple measure are added, the Value chip is generated. The given measures will remain in the Values zone, while the Values chip can be placed wherever required. The placement of the Values chip drives the location of the measures in the visualization.

  • Click here to learn more about the drop zones.
  • Click here to learn more about the Values drop zone.

 

There are several ways to add measures from the Measure Tree to the query.

Select

Simply select the checkbox of the measures you want to add to the query. Pyramid will add the selected measures to the drop zones automatically.

Double Click

Double click on the measure you want to add to the query. Pyramid will add the selected measures to the drop zones automatically.

Context Menu "Add To"

Right click on the measure; from the context menu go to Add To and choose the drop zone that you want to add the measure to.

Drag and Drop

Drag the measure from the Measure Tree; this will expose the drop zone icons in the middle of the page. You can drop the measure onto a drop zone icon, or directly onto the drop zone panel.

Select Highlights

To add multiple measures at once, hold the Shift or Ctrl keys and then click on the measure caption (NOT the measure checkbox). The selected measures will be highlighted orange (as shown below). Right click on one of the highlighted measures and click Select Highlights.

Moving Measures in the Drop Zones

Once measures are added to drop zones (and are in the query), they can be shifted around.

Drag and Drop

Move measures between the drop zones simply by dragging and dropping them.

Move To

Right click on a measure in the drop zone and go to Move To; select the required drop zone.

Copy Measures

Add the same measure to multiple drop zones using the following techniques by drag and dropping it or using the Add To method (both listed above). You can also use the Copy To function from the context menu (as described below).

Right click on the measure chip in the Drop Zone; go to Copy To and select the required drop zone.

Removing Measures from the Query

There are several methods to remove measure chips from the drop zones.

Measure Tree

Uncheck

Deselect the measure's checkbox in the Measure Tree.

Deselect All

Click the Deselect button to deselect all currently selected measures.

Deselect Highlights

Remove multiple measures from the query at once Shift or Ctrl + selecting (click on the measure caption, NOT the measure checkbox); the selected measures will be highlighted orange. Right click on one of the highlighted measures and click Deselect Highlights.

Drop Zones

Delete

Click the " x " on the measure chip in drop zone.

Right Click Context Menu

Right click on the measure chip in the drop zone and click Remove.